﻿create procedure [SqlVariant].[GetProperties] ( @p_SqlVariant sql_variant )
as
begin

  select Sql_Variant_Property( @p_SqlVariant, 'BaseType' ) As BaseType
        ,Sql_Variant_Property( @p_SqlVariant, 'Precision' ) As Precision
        ,Sql_Variant_Property( @p_SqlVariant, 'Scale' ) As Scale
        ,Sql_Variant_Property( @p_SqlVariant, 'TotalBytes' ) As TotalBytes
        ,Sql_Variant_Property( @p_SqlVariant, 'Collation' ) As Collation
        ,Sql_Variant_Property( @p_SqlVariant, 'MaxLength' ) As MaxLength

end